CREATE TABLE [dbo].[Fac]
(
[Ik_fac] [int] NOT NULL IDENTITY(1, 1),
[Cname_fac] [varchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL,
[Cshort_name_fac] [varchar] (20) COLLATE Cyrillic_General_CI_AS NULL,
[fDateExit] [datetime] NULL,
[bit_calc_nagr] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Fac] ADD CONSTRAINT [PK_Fac] PRIMARY KEY CLUSTERED  ([Ik_fac]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Fac] ADD CONSTRAINT [FacCname_facUnique] UNIQUE NONCLUSTERED  ([Cname_fac]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Fac] ADD CONSTRAINT [IX_Fac] UNIQUE NONCLUSTERED  ([Cshort_name_fac]) ON [PRIMARY]
GO
